package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.*;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_CompoundUniqueGroup({
        @_DDL_CompoundUnique(name = "UNI_dev_id_date", columns = {"dev_id", "date"})
})
@_DDL_Table(name = "t_statistics", simpleName = "", engine = MysqlDriver.InnoDB, comment = "交易统计表")
public class _DDL_Statistics {

    @_DDL_Primary()
    @_DDL_Column(name = "id", type = SqlType.INT_UNSIGNED, nullable = false, autoIncrement = true, comment = "id")
    private Long id;

    @_DDL_Index(name = "IDX_t_statistics_mer_id")
    @_DDL_Column(name = "mer_id", type = SqlType.BIGINT_UNSIGNED, comment = "商户id")
    private java.math.BigInteger merId;

    @_DDL_Column(name = "dev_id", type = SqlType.INT_UNSIGNED, comment = "设备id")
    private Long devId;

    @_DDL_Column(name = "date", type = SqlType.INT_UNSIGNED, comment = "日期")
    private Long date;

    @_DDL_Column(name = "month", type = SqlType.INT_UNSIGNED, comment = "月份")
    private Long month;

    @_DDL_Column(name = "trans_count", type = SqlType.INT_UNSIGNED, comment = "交易总数量")
    private Long transCount;

    @_DDL_Column(name = "refund_count", type = SqlType.INT_UNSIGNED, comment = "退款总数量")
    private Long refundCount;

    @_DDL_Column(name = "trans_amt", type = SqlType.DECIMAL, size = 10, scale = 2, comment = "交易总金额")
    private java.math.BigDecimal transAmt;

    @_DDL_Column(name = "refund_amt", type = SqlType.DECIMAL, size = 10, scale = 2, comment = "退款总金额")
    private java.math.BigDecimal refundAmt;

}
